﻿CREATE TABLE [dbo].[Order_Change_Hedge] (
    [Id]        INT              IDENTITY (1, 1) NOT FOR REPLICATION NOT NULL,
    [CId]       INT              CONSTRAINT [DF_Order_Change_Hedge_CId] DEFAULT ((0)) NOT NULL,
    [CusId]     UNIQUEIDENTIFIER NOT NULL,
    [CusName]   NVARCHAR (200)   CONSTRAINT [DF_Order_Change_Hedge_CusName] DEFAULT ('') NULL,
    [UpTime]    DATETIME         CONSTRAINT [DF_Finance_Hedge_UpTime] DEFAULT (getdate()) NOT NULL,
    [OId]       UNIQUEIDENTIFIER NOT NULL,
    [oldje]     DECIMAL (18, 2)  CONSTRAINT [DF_Finance_Hedge_old_YingShou] DEFAULT ((0)) NOT NULL,
    [newje]     DECIMAL (18, 2)  CONSTRAINT [DF_Finance_Hedge_new_YingShou] DEFAULT ((0)) NOT NULL,
    [dch_xj]    DECIMAL (18, 2)  CONSTRAINT [DF_Table_1_shyxj] DEFAULT ((0)) NOT NULL,
    [dch_yy]    DECIMAL (18, 2)  CONSTRAINT [DF_Table_1_shyyy] DEFAULT ((0)) NOT NULL,
    [dch_zhh]   DECIMAL (18, 2)  CONSTRAINT [DF_Finance_Hedge_dch_zhh] DEFAULT ((0)) NOT NULL,
    [dch_xzml]  DECIMAL (18, 2)  CONSTRAINT [DF_Finance_Hedge_dch_xzml] DEFAULT ((0)) NOT NULL,
    [dch_xfml]  DECIMAL (18, 2)  CONSTRAINT [DF_Finance_Hedge_dch_xfml] DEFAULT ((0)) NOT NULL,
    [dch_ysh]   DECIMAL (18, 2)  CONSTRAINT [DF_Finance_Hedge_dch_ysh] DEFAULT ((0)) NOT NULL,
    [dch_yf]    DECIMAL (18, 2)  CONSTRAINT [DF_Finance_Hedge_dch_yf] DEFAULT ((0)) NOT NULL,
    [dch_chd]   DECIMAL (18, 2)  CONSTRAINT [DF_Finance_Hedge_dch_chd] DEFAULT ((0)) NOT NULL,
    [dch_wk]    DECIMAL (18, 2)  CONSTRAINT [DF_Finance_Hedge_dch_wk] DEFAULT ((0)) NOT NULL,
    [CompanyId] INT              CONSTRAINT [DF_Finance_Hedge_CompanyId] DEFAULT ((0)) NOT NULL,
    CONSTRAINT [PK_Order_Change_Hedge_Id] PRIMARY KEY CLUSTERED ([Id] ASC)
);


GO
CREATE NONCLUSTERED INDEX [IX_Order_Change_Hedge_OId]
    ON [dbo].[Order_Change_Hedge]([OId] ASC);


GO
CREATE NONCLUSTERED INDEX [IX_Order_Change_Hedge_CId]
    ON [dbo].[Order_Change_Hedge]([CId] ASC);


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'客户编号', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Order_Change_Hedge', @level2type = N'COLUMN', @level2name = N'CusId';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'客户名称', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Order_Change_Hedge', @level2type = N'COLUMN', @level2name = N'CusName';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'成单总额(原单)', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Order_Change_Hedge', @level2type = N'COLUMN', @level2name = N'oldje';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'成单总额(新单)', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Order_Change_Hedge', @level2type = N'COLUMN', @level2name = N'newje';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'实有现金(对冲)', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Order_Change_Hedge', @level2type = N'COLUMN', @level2name = N'dch_xj';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'实有银行(对冲)', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Order_Change_Hedge', @level2type = N'COLUMN', @level2name = N'dch_yy';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'账户余额(对冲)', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Order_Change_Hedge', @level2type = N'COLUMN', @level2name = N'dch_zhh';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'新增毛利(对冲)', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Order_Change_Hedge', @level2type = N'COLUMN', @level2name = N'dch_xzml';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'续费毛利(对冲)', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Order_Change_Hedge', @level2type = N'COLUMN', @level2name = N'dch_xfml';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'新增应收(对冲)', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Order_Change_Hedge', @level2type = N'COLUMN', @level2name = N'dch_ysh';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'新增应付(对冲)', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Order_Change_Hedge', @level2type = N'COLUMN', @level2name = N'dch_yf';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'成单金额(对冲)', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Order_Change_Hedge', @level2type = N'COLUMN', @level2name = N'dch_chd';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'尾款(对冲)', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Order_Change_Hedge', @level2type = N'COLUMN', @level2name = N'dch_wk';

